Y7 Interactive Introduction to Spreadsheets

Spreadsheets are really useful they are great for:

Enter your name:

Spreadsheets are really useful they are great for:

Lists of data Processing numbers Both of these

The spreadsheet "introduction examples" has three sheets to look at.

Complete the lists on the "lists" sheet and do the tasks on "formatting" and "formula and functions" sheets.

Your teacher might go through this with the whole class.

You might also be given it as a MS Teams assignment; if not you can download it and open it from this link

Introduction examples spreadsheet

Standard lists can be completed by selecting the first item and dragging or zipping from the top right bottom right bottom left top left corner of the cells.

As well as text formatting there is additional number formatting. Using number formatting to get a £ symbol is formatting a number as percent currency date time

All spreadsheet formulae start with the symbol: + - / * = . In the formulae the cells are referenced using their column letter and row number. The cell reference for the cell in column B and row 4 is 4B B4 ref 4B cell B4 .

In this introduction there is a series of four basic spreadsheets with tasks to do on each one.

You might be given them as Teams assignment(s) - if not you can download them from here

Download and open: The basics 1  This spreadsheet gets you to practice adding by using:

=CELL_REFERENCE + CELL_REFERENCE

What is the advantage of adding using cell refernces rather than just adding the numbers?

It is quicker The answer changes if the numbers change It is more accurate

Download and open: The basics 2  This spreadsheet has two sheets.

1) "this one first" gets you to practice using the + - * / operators in formulae.

2) "then this one" gets you to write formulae using more than two cell references.

What is the correct formula for subtracting C4 from B4 then multiplying by D4?

=B4-C4*D4 =(B4-C4)*D4 =(C4-B4)/D4 =(C4-B4)*D4

Download and open: The basics 3  This spreadsheet has two sheets do the "simple" sheet. It has more practice at formula and then introduces you to the autosum button and the SUM formula. Do the "advanced" sheet if you are ahead of most people.

1) What is the best formula for adding cells E11 down to E20

=SUM(E11:E20) =E11:E20 =ADD(E11:E20)

=E11+E12+E13+E14+E15+E16+E17+E18+E19+E20

2) In the formula E11:E20 is called the.....?

cell parameter cell limit cell range

3) Write the best formula for adding all the cells from C2 down to C20

Download and open: The basics 4  This spreadsheet has two sheets do the "simple" sheet. It has more practice at the SUM formula and then you try the AVERAGE formula. Try the "advanced" sheet as well.

If you write "10 pence" into a cell and "5 pence" into another and try to add them what will be the result?

15 pence #VALUE

Why?

Well done you have completed the Introduction to Spreadsheets.

Make a new spreadsheet, enter some numbers into it and try some of the other functions out.

To find them click the fx button or More Functions from the AutoSum drop down menu.

You are currently doing Change to task